Hello Chris/Connor, Hope you are doing well. We are using ExaC@C with 19c databases at work and are exploring whether we can use PDB Snapshot Carousel and/or PDB Snapshot Copy feature. It might be just me but I am somewhat confused with the "art of possible" while using ASM. PDB ...

Hello Connor/Chris, Hope you are doing well. Not sure if I am missing something obvious but is there a way to limit execution of specific SQL ID to a certain amount of elapsed time/CPU time? I looked at Resource Manager but it only allows to affect based on user/service/action. A...

There are files that contain special characters (i.e. $, #) in the name, and SQL Plus cannot find them. $ sqlplus -L user/password@host:port/SID @/path/to/file/create$spec_view.sql SQL*Plus: Release 12.2.0.1.0 Production on Thu Dec 13 17:29:54 2018 Copyright (c) 1982, 2016, Ora

Hi Team, Recently, while reading articles by Maria Colgan, I found out that I was able to generate reports from the v$sql_monitor info that help me alot when I am trying to find out what is happening to the performance on our systems. I am also using the historic view DBA_HIST_RE...

Hi Tom. When running a DML, the dba_tab_statistics, stale_stats column will be set to "YES" for the related table also when it was before "NO". It will remain to yes, also when the entire transaction was rolled back. So it looks like the update in dba_tab_statistics set stale_sta...